 /*  SAS Data Definition File                        */
 /*  Created by ddltox on Mar 28, 2002  (Thu 02:33 PM PST)  */
 /*  DDL source file: "/u/d7/big/sda_1.2a/tmpdir/AAPuaObr.txt".  */

/* DDL indicates that dataset record length (reclen) is 61 columns. */

TITLE "ORANGE COUNTY ANNUAL SURVEY";
FILENAME INDATA "    ";      /* Put name of data file between quotes */
LIBNAME LIBRARY "    ";    /* Put directory of data library between quotes */

PROC  FORMAT LIB=LIBRARY;
  VALUE CASEID    1='RANDOM SAMPLE' 2='UCI DONORS' ;
  VALUE Q1f       1='SINGLE FAMILY' 2='ATTACHED' 3='APARTMENT' 4='MOBILE' 
                  5='OTHER' 9='REFUSE' ;
  VALUE Q2f       1='0-2 YRS' 2='3-5 YRS' 3='6-10 YRS' 4='11-20 YRS' 
                  5='21+ YRS' 9='REFUSE' ;
  VALUE Q3f       1='0-2 YRS' 2='3-5 YRS' 3='6-10 YRS' 4='11-20 YRS' 
                  5='21+ YRS' 9='REFUSE' ;
  VALUE Q4f       1='OWN' 2='RENT' 9='DK, REFUSE' ;
  VALUE Q5f       1='UNDER $500' 2='$501-$750' 3='$751-$1,000' 
                  4='$1,001-$1,500' 5='$1,501+' 9='NA, REFUSE' ;
  VALUE Q6f       1='NOTHING' 2='$1-$500' 3='$501-$750' 4='$751-$1,000' 
                  5='$1,001-$1,500' 6='$1,501-$2,000' 7='$2,001+' 
                  9='NA, REFUSE' ;
  VALUE Q7f       1='BETTER OFF' 2='WORSE OFF' 3='SAME' 9='DK, REFUSE' ;
  VALUE Q8f       1='BETTER OFF' 2='WORSE OFF' 3='SAME' 8='DK' 9='REFUSE' ;
  VALUE Q9f       1='GOOD TIMES' 2='BAD TIMES' 8='DK' 9='REFUSE' ;
  VALUE Q10f      1='GOOD TIMES' 2='DEPRESSION' 8='DK' 9='REFUSE' ;
  VALUE Q11f      1='GOOD TIME' 2='BAD TIME' 8='NEITHER, DK' 9='REFUSE' ;
  VALUE Q12f      1='EXCELLENT' 2='GOOD' 3='FAIR' 4='POOR' 8='DK' 9='REFUSE' ;
  VALUE Q13f      1='MUCH BETTER' 2='SOMEWHAT BETTER' 3='SAME' 
                  4='SOMEWHAT WORSE' 5='MUCH WORSE' 8='DK' 9='REFUSE' ;
  VALUE Q14f      1='EXCELLENT' 2='GOOD' 3='FAIR' 4='POOR' 8='DK' 9='REFUSE' ;
  VALUE Q15f      1='VERY SATISFIED' 2='SOMEWHAT SAT' 3='SOMEWHAT DISSAT' 
                  4='VERY DISSAT' 8='DK' 9='REFUSE' ;
  VALUE Q16f      1='A LOT' 2='SOMEWHAT' 3='A LITTLE' 4='NOT AT ALL' 
                  5='ALREADY LOST' 8='DK' 9='REFUSE' ;
  VALUE Q17f      1='A LOT' 2='SOME' 3='VERY LITTLE' 4='NONE' 8='DK' 
                  9='REFUSE' ;
  VALUE Q18f      1='FAVOR' 2='OPPOSE' 8='DK' 9='REFUSE' ;
  VALUE Q19f      1='VERY WELL' 2='SOMEWHAT WELL' 3='SOMEWHAT BADLY' 
                  4='VERY BADLY' 9='DK, REFUSE' ;
  VALUE Q20f      1='GROWTH' 2='TRAFFIC' 3='HOUSING' 4='CRIME' 5='SCHOOLS' 
                  6='IMMIGRATION' 7='ECONOMY' 8='OTHER' 9='DK, REFUSE' ;
  VALUE Q21f      1='HEALTH CARE' 2='CHILD CARE' 3='RACE RELATIONS' 
                  4='HOMELESS' 5='DRUG ABUSE' 6='AIDS' 7='OTHER' 
                  9='DK, REFUSE' ;
  VALUE Q22f      1='BETTER PLACE' 2='WORSE PLACE' 3='NO CHANGE' 
                  9='DK, REFUSE' ;
  VALUE Q23f      1='GROWING RAPIDLY' 2='GROWING SLOWLY' 3='STAYING SAME' 
                  4='LOSING POP' 8='DK' 9='REFUSE' ;
  VALUE Q24f      1='TOO STRICT' 2='ABOUT RIGHT' 3='NOT STRICT ENOUGH' 
                  9='DK,REFUSE' ;
  VALUE Q25f      1='SATISFACTORY' 2='MORE LANES ONLY' 3='NEW FREEWAYS' 
                  9='DK, REFUSE' ;
  VALUE Q26f      1='FAVOR' 2='OPPOSE' 8='DK' 9='REFUSE' ;
  VALUE Q31f      1='VERY SERIOUS' 2='SOMEWHAT SERIOUS' 3='NOT TOO SERIOUS' 
                  8='DK' 9='REFUSE' ;
  VALUE Q32f      1='YES' 2='NO' 8='DK' 9='REFUSE' ;
  VALUE Q33f      1='YES' 2='NO' 8='DK' 9='REFUSE' ;
  VALUE Q34f      1='INCREASED A LOT' 2='INCREASED SOME' 3='SAME' 
                  4='DECREASED SOME' 5='DECREASED A LOT' 8='DK' 9='REFUSE' ;
  VALUE Q35f      1='YES' 2='NO' 8='DK' 9='REFUSE' ;
  VALUE Q36f      1='FULL-TIME' 2='PART-TIME' 3='NOT EMPLOYED' 9='REFUSE' ;
  VALUE Q37f      1='NORTH' 2='WEST' 3='CENTRAL' 4='SOUTH' 5='OUTSIDE OC' 
                  9='NO ANS' ;
  VALUE Q38f      1='DRIVE ALONE' 2='CARPOOL' 3='VANPOOL' 4='PUBLIC TRANSIT' 
                  5='OTHER' 9='DK, REFUSE' ;
  VALUE Q39f      1='NO PROBLEM' 2='SOME PROBLEM' 3='GREAT PROBLEM' 9='NA' ;
  VALUE Q40f      1='GOTTEN BETTER' 2='GOTTEN WORSE' 3='STAYED SAME' 9='NA' ;
  VALUE Q81f      1='NOTHING' 2='$1-$100' 3='$101-$250' 4='$251-$500' 
                  5='$501-$999' 6='$1000+' 9='DK, REFUSE' ;
  VALUE Q82f      1='18-34' 2='35-54' 3='55+' 9='REFUSE' ;
  VALUE Q83f      1='< H.S.' 2='H.S. GRAD' 3='SOME COLLEGE' 4='COLLEGE GRAD' 
                  5='POST GRAD' 9='REFUSE' ;
  VALUE Q84f      0='NONE' 1='ONE' 2='TWO' 3='THREE OR MORE' 9='REFUSE' ;
  VALUE Q85f      1='NORTH' 2='WEST' 3='CENTRAL' 4='SOUTH' 5='OUTSIDE OC' 
                  9='NO ANS' ;
  VALUE Q86f      1='UNDER $36,000' 2='$36,000-$50,000' 3='$50,001-$79,999' 
                  4='$80,000+' 9='DK, REFUSE' ;
  VALUE Q87f      1='VERY LIBERAL' 2='SOMEWHAT LIBERAL' 3='MIDDLE OF ROAD' 
                  4='SOMEWHAT CONSERV' 5='VERY CONSERV' 9='REFUSE' ;
  VALUE Q88f      1='DEMOCRAT' 2='REPUBLICAN' 3='INDEP/OTHER' 
                  4='NOT REGISTERED' 9='REFUSE' ;
  VALUE Q89f      1='YES' 2='NO' 8='DK' 9='NA' ;
  VALUE Q90f      1='YES' 2='NO' 8='DK' 9='NA' ;
  VALUE Q91f      1='YES' 2='NO' 8='DK' 9='NA' ;
  VALUE Q92f      0='NEVER' 1='1X' 2='2X' 3='3X' 4='4X+' 8='DK' 9='REFUSE' ;
  VALUE Q93f      1='ASIAN' 2='BLACK' 3='HISPANIC' 4='CAUCASIAN' 5='OTHER' 
                  9='REFUSE' ;
  VALUE Q94f      1='MALE' 2='FEMALE' ;
  VALUE LANG      1='ENGLISH' 2='SPANISH' ;
  VALUE YEAR      1993='YEAR OF SURVEY' ;
RUN;

DATA IN (LABEL="ORANGE COUNTY ANNUAL SURVEY");
  INFILE INDATA LRECL=61;
  INPUT
    #1  CASEID 1-4              Q1 5                    Q2 6                    
        Q3 7                    Q4 8                    Q5 9                    
        Q6 10                   Q7 11                   Q8 12                   
        Q9 13                   Q10 14                  Q11 15                  
        Q12 16                  Q13 17                  Q14 18                  
        Q15 19                  Q16 20                  Q17 21                  
        Q18 22                  Q19 23                  Q20 24                  
        Q21 25                  Q22 26                  Q23 27                  
        Q24 28                  Q25 29                  Q26 30                  
        Q31 31                  Q32 32                  Q33 33                  
        Q34 34                  Q35 35                  Q36 36                  
        Q37 37-38               Q38 39                  Q39 40                  
        Q40 41                  Q81 42                  Q82 43                  
        Q83 44                  Q84 45                  Q85 46-47               
        Q86 48                  Q87 49                  Q88 50                  
        Q89 51                  Q90 52                  Q91 53                  
        Q92 54                  Q93 55                  Q94 56                  
        LANG 57                 YEAR 58-61              ;

  LABEL
   CASEID  = 'CASE ID'
   Q1      = 'TYPE OF CURRENT RESIDENCE'
   Q2      = 'HOW LONG LIVE IN OC'
   Q3      = 'HOW LONG LIVE AT CURRENT RESIDENCE'
   Q4      = 'OWN/RENT PRESENT RESIDENCE'
   Q5      = 'MONTHLY RENTAL PAYMENT'
   Q6      = 'MONTHLY MORTGAGE PAYMENT'
   Q7      = 'BETTER OFF/WORSE OFF/SAME LAST YEAR'
   Q8      = 'BETTER OFF/WORSE OFF/SAME NEXT YEAR'
   Q9      = 'NAT''L BUSINESS CONDS NEXT 12 MO'
   Q10     = 'NAT''L CONDS NEXT 5 YEARS'
   Q11     = 'GD/BAD TIME TO BUY MAJ HSEHOLD ITEMS'
   Q12     = 'RATE ECONOMY IN OC TODAY'
   Q13     = 'OC ECONOMY 2 YRS FROM NOW'
   Q14     = 'BUYING OC HOME GOOD INVESTMENT TODAY'
   Q15     = 'HOW SATISFIED W/ FINANCIAL SITUATION'
   Q16     = 'WORRY THAT YOU/FAMILY WILL LOSE JOB'
   Q17     = 'CONFIDENCE IN GOVT PLAN FOR EL TORO'
   Q18     = 'COMMERCIAL AIRPORT AT EL TORO'
   Q19     = 'QUALITY OF LIFE IN OC'
   Q20     = 'MOST SERIOUS PUBLIC POLICY PROBLEM'
   Q21     = 'MOST SERIOUS SOCIAL PROBLEM'
   Q22     = 'OC IN FUTURE'
   Q23     = 'POP GROWTH IN CITY PAST FEW YRS'
   Q24     = 'CURRENT GROWTH REGS IN CITY'
   Q25     = 'FEELING ABOUT FREEWAYS IN OC'
   Q26     = 'OPINION OF THREE TOLLROADS'
   Q31     = 'HOW SERIOUS A THREAT ARE ENV PROBS'
   Q32     = 'ACCEPT UNEMPLOYMENT TO PROTECT ENV'
   Q33     = 'SAFE TO WALK IN YR AREA AT NIGHT'
   Q34     = 'CRIME AND GANGS IN PAST FEW YRS'
   Q35     = 'BEEN CRIME VICTIM IN PAST YR'
   Q36     = 'WORK STATUS'
   Q37     = 'WORKPLACE'
   Q38     = 'HOW COMMUTE TO WORK'
   Q39     = 'TRAFFIC CONGESTION DURING COMMUTE'
   Q40     = 'CONGESTION PROBLEM OVER TIME'
   Q81     = '$ GAVE TO ALL CHARITIES LAST YR'
   Q82     = 'AGE'
   Q83     = 'EDUCATION'
   Q84     = 'NUMBER OF CHILDREN IN HHOLD'
   Q85     = 'RESIDENCE'
   Q86     = 'ANNUAL HOUSEHOLD INCOME'
   Q87     = 'CONSIDER YOURSELF POLITICALLY:'
   Q88     = 'PARTY'
   Q89     = 'VOTE ON PROP 170'
   Q90     = 'VOTE ON PROP 172'
   Q91     = 'VOTE ON PROP 174'
   Q92     = 'VOTED IN PAST 4 YRS'
   Q93     = 'RACE'
   Q94     = 'SEX'
   LANG    = 'LANGUAGE OF INTERVIEW'
   YEAR    = 'YEAR OF SURVEY'  ;
  FORMAT CASEID CASEID. Q1 Q1f. Q2 Q2f. 
         Q3 Q3f. Q4 Q4f. Q5 Q5f. 
         Q6 Q6f. Q7 Q7f. Q8 Q8f. 
         Q9 Q9f. Q10 Q10f. Q11 Q11f. 
         Q12 Q12f. Q13 Q13f. Q14 Q14f. 
         Q15 Q15f. Q16 Q16f. Q17 Q17f. 
         Q18 Q18f. Q19 Q19f. Q20 Q20f. 
         Q21 Q21f. Q22 Q22f. Q23 Q23f. 
         Q24 Q24f. Q25 Q25f. Q26 Q26f. 
         Q31 Q31f. Q32 Q32f. Q33 Q33f. 
         Q34 Q34f. Q35 Q35f. Q36 Q36f. 
         Q37 Q37f. Q38 Q38f. Q39 Q39f. 
         Q40 Q40f. Q81 Q81f. Q82 Q82f. 
         Q83 Q83f. Q84 Q84f. Q85 Q85f. 
         Q86 Q86f. Q87 Q87f. Q88 Q88f. 
         Q89 Q89f. Q90 Q90f. Q91 Q91f. 
         Q92 Q92f. Q93 Q93f. Q94 Q94f. 
         LANG LANG. YEAR YEAR.  ;

/* md, min and max specifications were translated  */
/* into the following "IF" statements:           */

IF (Q1 = 9) THEN Q1 = .;
IF (Q2 = 9) THEN Q2 = .;
IF (Q3 = 9) THEN Q3 = .;
IF (Q4 = 9) THEN Q4 = .;
IF (Q5 = 9) THEN Q5 = .;
IF (Q6 = 9) THEN Q6 = .;
IF (Q7 = 9) THEN Q7 = .;
IF (Q8 = 9) THEN Q8 = .;
IF (Q9 = 9) THEN Q9 = .;
IF (Q10 = 9) THEN Q10 = .;
IF (Q11 = 9) THEN Q11 = .;
IF (Q12 = 9) THEN Q12 = .;
IF (Q13 = 9) THEN Q13 = .;
IF (Q14 = 9) THEN Q14 = .;
IF (Q15 = 9) THEN Q15 = .;
IF (Q16 = 9) THEN Q16 = .;
IF (Q17 = 9) THEN Q17 = .;
IF (Q18 = 9) THEN Q18 = .;
IF (Q19 = 9) THEN Q19 = .;
IF (Q20 = 9) THEN Q20 = .;
IF (Q21 = 9) THEN Q21 = .;
IF (Q22 = 9) THEN Q22 = .;
IF (Q23 = 9) THEN Q23 = .;
IF (Q24 = 9) THEN Q24 = .;
IF (Q25 = 9) THEN Q25 = .;
IF (Q26 = 9) THEN Q26 = .;
IF (Q31 = 9) THEN Q31 = .;
IF (Q32 = 9) THEN Q32 = .;
IF (Q33 = 9) THEN Q33 = .;
IF (Q34 = 9) THEN Q34 = .;
IF (Q35 = 9) THEN Q35 = .;
IF (Q36 = 9) THEN Q36 = .;
IF (Q37 = 98) THEN Q37 = .;
IF (Q38 = 9) THEN Q38 = .;
IF (Q39 = 9) THEN Q39 = .;
IF (Q40 = 9) THEN Q40 = .;
IF (Q81 = 9) THEN Q81 = .;
IF (Q82 = 9) THEN Q82 = .;
IF (Q83 = 9) THEN Q83 = .;
IF (Q84 = 9) THEN Q84 = .;
IF (Q85 = 99) THEN Q85 = .;
IF (Q86 = 9) THEN Q86 = .;
IF (Q87 = 9) THEN Q87 = .;
IF (Q88 = 9) THEN Q88 = .;
IF (Q89 = 9) THEN Q89 = .;
IF (Q90 = 9) THEN Q90 = .;
IF (Q91 = 9) THEN Q91 = .;
IF (Q92 = 9) THEN Q92 = .;
IF (Q93 = 9) THEN Q93 = .;

PROC DATASETS;
  CONTENTS DATA=IN POSITION;
  TITLE 'CONTENTS OF ALL VARIABLES';
RUN;
